Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | SaleReturnLineItem(TR_LTM_SLS_RTN) |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | SaleReturnLineItem(TR_LTM_SLS_RTN) |
QuestionID (FK) | A unique identifer for the restriction validation question. | ID_QST_RST_VLD | Identity | integer | RestrictionValidationQuestion(CO_VLD_RST_QST) |
AddressID (FK) | A unique system allocated identifier for the Address. | ID_ADS | Identity | integer | Address(LO_ADS) |
Answer | The answer given by the customer to the given question. | NA_ANS | DescriptionShort | varchar(255) | |
EntryMethod | A code to denote how the answer to the RestrictionValidationQuestion was entered at the Workstation. Example values include: Keyed, Barcode, MICR, MSR, SmartCard. | CD_MTH_ENR | Code4 | char(4) | |